#!/bin/sh
currentDate=`date +%Y-%m-%d`
/opt/lagou/servers/hive-2.3.7/bin/hive -e "use default;insert into table user_info select count(1), '$currentDate' from(select id, '$currentDate' from user_clicks where to_date(click_time)='$currentDate' group by id) tmp;"
